Interview Questions

1. SSAS does not Support Role Based Security is it true or false?

Options:

a. True

b. False

Reveal Answer

2. The Analysis Services __________ role defines administrative access of Windows users and groups to an instance of Analysis Services.

Options:

a. Database

b. Server

c. User

d. None of the mentioned

Reveal Answer

3. Point out the correct statement:

Options:

a. The permissions of a role may allow members to access and administer the database

b. Server roles, roles defined by administrators to control access to objects and data for non-administrator user

c. Database roles, roles defined by administrators to control access to objects and data for administrator user

d. None of the mentioned

Reveal Answer

4. Which of the following role is created as a separate object in an Analysis Services database, and applies only to the database in which that role is created?

Options:

a. Database

b. Membership

c. Client

d. Server

Reveal Answer

5. Which of the following permission setting provides internal computation permission?

Options:

a. Unsafe

b. External Access

c. Safe

d. All of the mentioned

Reveal Answer

6. You are managing a SQL Server 2008 Analysis Services (SSAS) instance for Company.com. In order to execute the Usage-Based Optimization Wizard, you should make query logging enable.Which is the correct answer? Which is the correct answer?

Options:

a. You should make the QueryLogSampling server attribute default value

b. You should make the QueryLogSampling server attribute 5

c. You should configure the server property of default folders

d. You should configure the QueryLogConnectionString server attribute and set a valid connection string

Reveal Answer

7. Security for stored procedures is set with the _________ property on a stored procedure.

Options:

a. PermissionSet

b. SetPermissionSet

c. Permission

d. None of the mentioned

Reveal Answer

8. Can we set additional permissions that explicitly allow or deny access to dimension members?

Options:

a. Yes

b. No

Reveal Answer

9. Cell security is used to _________?

Options:

a. allow or deny access to measure data within a cube

b. allow or deny access to measure data within a dimension

c. None of these

Reveal Answer

10. Cell permissions apply to data inside the cell, and to its metadata?

Options:

a. True

b. False

Reveal Answer

Interview Questions and Answer

1. SSAS does not Support Role Based Security is it true or false?

2. The Analysis Services __________ role defines administrative access of Windows users and groups to an instance of Analysis Services.

3. Point out the correct statement:

4. Which of the following role is created as a separate object in an Analysis Services database, and applies only to the database in which that role is created?

5. Which of the following permission setting provides internal computation permission?

6. You are managing a SQL Server 2008 Analysis Services (SSAS) instance for Company.com. In order to execute the Usage-Based Optimization Wizard, you should make query logging enable.Which is the correct answer? Which is the correct answer?

7. Security for stored procedures is set with the _________ property on a stored procedure.

8. Can we set additional permissions that explicitly allow or deny access to dimension members?

9. Cell security is used to _________?

10. Cell permissions apply to data inside the cell, and to its metadata?

Packages

Trending Certification Courses:

Microsoft Mock Exams:

Other links

About

Resources